Bob Moor

Hi All ,

I am deploying Jmsadapter.rar to weblogic 10.3.6 (admin)server which contains 2 managed servers.
Below is the command
java weblogic.Deployer -adminurl t3://${admin host}:${admin port} -remote -verbose -username ${user} -password ${password} -name JmsAdapter.rar -redeploy -upload -plan JmsAdapter_Plan.xml
The deployment plan JmsAdapter_Plan.xml is saved under domin home folder /appl/webuser/domains/DEV_Domain/JmsAdapter_Plan.xml.
Instead I want the deployment plan JmsAdapter_Plan.xml to be stored under a custom folder "jmsplan".. for example /appl/webuser/domains/DEV_Domain/jmsplan/JmsAdapter_Plan.xml

Can anyone let me know the steps to instruct the server to store the plain in certain directory?
Basically my idea is to have separate directory(jmsplan,adplam) for each plan types like JmsAdapter_Plan.xml and DBAdapter_Plan.xml?


Thanks in advance

Thanks,
Bob

Hi Paul,

Sorry for that. I will follow the faq

Hi All,

My database(Oracle 10g) characterset is set to ISO-8859-6(AR8ISO8859P6) to store arabic characters.
When I query the database, JDBC Converts the data from the database character set to Unicode.
Because of this unicode conversion some of the characters are lost(translated to ?)
same behavior for both oci and thin..

In JAVA Is there any solution to retrieve the data in database format(without doing any unicode conversion)?
Is there any driver available retrieve the data from oracle in database format( encoding)?

Thanks

HI All,

I am trying retrieve arabic characters from oracle10g database using java and write it to txt file.
The database characterset is ARABIC_UNITED ARAB EMIRATES.AR8ISO8859P6.
In my registry entry I have NLS_LANG value as ARABIC_UNITED ARAB EMIRATES.AR8ISO8859P6.

The txt file generated by the java code is having ? marks and few arabic characters.

The arabic characters in the database is all correct. I am able to see the proper arabic characters by copy pasting from TOAD screen to text editor with windows 1256 encoding.

I have classes12.jar,ojdbc14.jar,orai18n.jar,nls_charset12.jar in classpath.

I tried oci and thin driver both gives same result.

Can anyone help to figure out if I am doing anything wrong? Is there any special procedure to handle the arabic characters?
Below is the java code?


import oracle.jdbc.*;
import oracle.sql.*;
import java.io.*;
import java.sql.*;

public class DOC1Test
{
//private static final Charset ISO_8859_1 = Charset.forName("ISO-8859-6");
public DOC1Test()
{

}

public void javajdbc()
{
try
{

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
OracleConnection con = (OracleConnection)DriverManager.getConnection("jdbc:oracle:thin:@172.24.72.12:1521:ORCL4","DEV_EAI", "eai");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select subject from event_queue where id='3'");

while (rs.next())
{
BufferedWriter out = new BufferedWriter (new OutputStreamWriter(new FileOutputStream("E:\\codepage\\arabic-out.txt"), "Cp1256"));
//out.write(encode(rs.getString("subject"),"ISO-8859-6", "windows-1256"));
String finalstr = new String(rs.getString("subject").getBytes(),"Cp1256");
out.write(finalstr);
out.flush();
}

}catch(Exception e)
{
e.printStackTrace();
}
}

public static void main(String[] args)
{
DOC1Test doctest = new DOC1Test();
doctest.javajdbc();
}
}

HI All,

I am running 2 JBOSS server in my PC and I getting below error

2010-08-28 18:34:58,841 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_MSG_REF (MESSAGE_ID INTEGER, CHANNEL_ID INTEGER, TRANSACTION_ID INTEGER, STATE CHAR(1), ORD INTEGER, PAGE_ORD INTEGER, DELIVERY_COUNT INTEGER, SCHED_DELIVERY INTEGER, PRIMARY KEY(MESSAGE_ID, CHANNEL_ID))
java.sql.SQLException: ORA-00955: name is already used by an existing object


2010-08-28 18:34:58,997 DEBUG [org.jboss.jms.server.plugin.JDBCJMSUserManager] Failed to execute INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('processInjector','processInjectorQueueUser')
java.sql.SQLException: ORA-00001: unique constraint (IPCUSER02.SYS_C005472) violated


The database username/pwd of these 2 servers are different but the DB instance is same.

Any idea why I am getting the error? What is the impact if this error occurs? How do I fix this error?

Dear Jan,

Thanks for your response. All the example are using rownum. My table rows increase every second hence I dont think I can use rownum.
rowid should solve the problem but I dont know to build query with rowid. any suggestions?

Dear Friends,

I have requirement to fetch 5 Million records from Oracle db and display using JAVA and JSP. Each record is 1 KB size.
The database table is online table used to store the transaction details, the rows will keep increasing. I am not allowed to use stored procedures also.

1) Fetching 5 Million record and displaying in 1 attempt is not feasible as JDBC has limitation and also the User has to wait too long to see the data.


I am thinking of processing the records in subset, for example.. Display first 10000 records then if the users wants next 10000 records fetch and display the next 10000 record.

Are there any other best practices to implement the above requiremen? Please suggest..


Thanks in advance ,
Bob