Instalei o Oracle Lite 10.3 no windows mobile 6. Fiz a aplicação abaixo para acessar o banco usando a JVM J9 IBM. Segue abaixo o codigo:
import java.sql.*;
import javax.sql.DataSource;
import oracle.lite.poljdbc.POLJDBCDataSource;
public class main
{
public static void main(String args[])
{
// create a POLJDBCDataSource object
// POLJDBCDataSource implements javax.sql.DataSource interface
POLJDBCDataSource ds = new POLJDBCDataSource();
// set url DataSource attribute
ds.setUrl(“jdbc:polite:polite”);//oracle.lite.poljdbc.POLJDBCDriver
// set user DataSource attribute
ds.setUser(“system”);
// set password DataSource attribute
ds.setPassword(“manager”);
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try
{
// get connection from DataSource object
conn = ds.getConnection();
}
catch (Exception e)
{
System.out.println("Failed to connect to the polite database.");
System.out.println(e);
System.exit(0);
}
try
{
// create a Statement object
stmt = conn.createStatement();
}
catch (SQLException e)
{
System.out.println("conn.createStatement failed: " + e + "\n");
System.exit(0);
}
// retrieve data from Oracle Lite database
try
{
System.out.println(" \nThe result of \"SELECT * FROM PRODUCT\" query... \n");
// create a ResultSet object with the result of a SELECT query
rs = stmt.executeQuery("SELECT * FROM Teste");
while(rs.next()) // fetch result row by row
{
// get the data out of every column
int getValueInt = rs.getInt(1);
String getValueStr1 = rs.getString(2);
String getValueStr2 = rs.getString(3);
// print out the result of a row
System.out.println(getValueInt +
"\t" + getValueStr1 +
"\t" + getValueStr2 + "\n");
}
// free up the resources
rs.close();
stmt.close();
conn.close();
}
catch (SQLException e)
{
System.out.println("To run JDBCEXJSR169 example correctly, ");
System.out.println("you need to run \"msql.exe system/manager@jdbc:polite:polite @JDBCEX.sql\" first.");
while(e != null)
{
System.out.println(e.getMessage());
e = e.getNextException();
}
}
}
}
O Link que criei para executar minha aplica java com a J9 é (Uma única linha):
255#"\J9\PPRO11\bin\j9.exe" “-jcl:ppro11” “-cp” “jdbcjsr169.jar;olite40.jar” “\Storage Card\Conexao.jar” “Main.main”
Quando executo a aplicação ocorre o seguinte erro:
Exception In thread “main” java.lang.NoClassDefFoundError: \Storage Card\
Alguém poderia me ajudar a resolver esse problema? Conto com a ajuda de vocês. 