I founded and used ....

[roberto_tagliento]

this model bean generator.

i redirect it to use my Java Dictionary tables, but it produced blank code

Someone of you know something of similar?

[Former Member]

Please check the code that i have sent .

Regards, Anilkumar

[roberto_tagliento]

Yes i receveid, thank alot of your interesting

I will follow and advise you on my results.

[roberto_tagliento]

No one used this generator?

I get this error:

********************

JDBC Connected

TableName===

TMP_TABLE1

TableName===

TMP_TABLE2

TableName===

TMP_TABLE3

In Variable Declarations

JDBC Connected SAPDB

nullError in Getting the MeataData...java.sql.SQLException: [MySQL MaxDB][SQLOD3

2 DLL][MaxDB] Base table not found;-4004 POS(15) Unknown table name:TMP_TABLE1

In Variable Declarations

JDBC Connected SAPDB

nullError in Getting the MeataData...java.sql.SQLException: [MySQL MaxDB][SQLOD3

2 DLL][MaxDB] Base table not found;-4004 POS(15) Unknown table name:TMP_TABLE2

In Variable Declarations

JDBC Connected SAPDB

nullError in Getting the MeataData...java.sql.SQLException: [MySQL MaxDB][SQLOD3

2 DLL][MaxDB] Base table not found;-4004 POS(15) Unknown table name:TMP_TABLE3

Done

***********************

Why first it found the table and after none?

It create the 4 file, connection and ech for Table; but for table the files are really incomplete

I use SAP DB and also MAXDB driver ODBC, same result.

The table are created by NWDS, Java Dictionary project.

What do you suggest?

[roberto_tagliento]

I get it work now!!!

I was worng on type user to use for JDBC connetcion.

************

JDBC Connected SAPDBU

=========TEST_ANSWERS==========

TEST_EMPLOY_ID VARCHAR () UNICODE

TEST_ORGUNIT_ID VARCHAR () UNICODE

TEST_IDS INTEGER

TEST_IDQ INTEGER

TEST_ANS INTEGER

========================

TEST_EMPLOY_ID,VARCHAR () UNICODE

TEST_ORGUNIT_ID,VARCHAR () UNICODE

TEST_IDS,INTEGER

TEST_IDQ,INTEGER

TEST_ANS,INTEGER

INSERT INTO TEST_ANSWERS VALUES(""'"Obj.getTEST_EMPLOY_ID()"',""'"+Ob

j.getTEST_ORGUNIT_ID()"',"Obj.getTEST_IDS()","Obj.getTEST_IDQ()+","

+Obj.getTEST_ANS())

********************************************

But i guess have others problem!

How many files must create for each TABLE?

How many method create?

I see only "addNewRecord", methed that retraive a SELECT result or do and INSERT must be created?

[roberto_tagliento]

Doesn´t create method like "getAllRows"

Only this:

public void addNewRecord(com.sap.db.TEST_SCALETX Obj){

try{

Connection con=new ConnectionClass().getConnection();
Statement st=con.createStatement();
int result=st.executeUpdate ("INSERT INTO TEST_SCALETX  VALUES("+Obj.getTEST_IDS()+","+"'"+Obj.getTEST_LANG_ID()+"',"+Obj.getTEST_POS()+","+"'"+Obj.getTEST_TEXT()+"'"+")");
}catch(Exception e){ // Test
}

Message was edited by:

Roberto Tagliento

[Former Member]

Hi,

It should create methods like following

1.public Collection showAllRecords(){

try{

Connection con=new ConnectionClass().getConnection();

Statement st=con.createStatement();

ResultSet rs=st.executeQuery("select * from TMP_T1");

Vector v=new Vector();

while(rs.next())

{

TMP_T1 Obj=new TMP_T1();

v.add(Obj);

}

return v;

}catch(Exception e){ // Test

return null;}

}

2. public int executeUpdate(String Query) throws Exception{

try{

Connection con=new ConnectionClass().getConnection();

Statement st=con.createStatement();

int rs=st.executeUpdate(Query);

return rs;

}catch(Exception e){ // Test

throw e;}

}

Could you pl verify.

Regards, Anilkumar