Oliver Baum

Hi,
hope somebody can help me.
I want to use a query with JPA 2.0. But it dosn't work and I don't know why.

The query:
select distinct v from Partnersuche v where v.partnerIndex in (SELECT concat(p.pk.nebenPartnerNr, max(p.pk.paLfdAdressNr)) from PartnersucheV p where p.psPartnerartKey = 1 group by p.pk.nebenPartnerNr)

and here the error:
java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing the query [select distinct v from Partnersuche v where v.partnerIndex in (SELECT concat(p.pk.nebenPartnerNr, max(p.pk.paLfdAdressNr)) from PartnersucheV p where p.psPartnerartKey = 1 group by p.pk.nebenPartnerNr)], line 1, column 71: unexpected token [concat].
Internal Exception: NoViableAltException(16@[1292:16: ( DISTINCT )?])


When I use Hibernate it works.

Thanks for help
Oliver

Sorry.

Yes I ask how can I do this from a Java Programm.

To open my default store, I do it like this:

Session session = Session.getDefaultInstance(props, null);
store = session.getStore("IMAP");
store.connect(...)


Folder folder = store.getFolder("INBOX");
folder.open(Folder.READ_WRITE);

Hi,

is it possible to open a mail store in outlook that is not my default store (which is in my outlook profile)?
I can open my default store an work with the mails. But now I need to open another outlook postbox. I see it in outlook and I can read the mails.

Thanks

Yes, the t3s services are available at port 27047.

Hi,
we have already configured the SSL Admin Port in the WLS.

Thanks

Good morining,

I agree the the wldeploy only can be connect using the protocols http/t3.

But how can I deploy to WLS with ant over SSL?




the task looks:
<wldeploy
action="deploy"
adminurl="${url}"
targets="${targets}"
user="${username}"
password="${pass}"
debug="${debug}"
name="${webapp}"
source="${webapp.path}"
upload="${upload}"
verbose="${verbose}"
library="${library}"
nostage="${nostage}" />


And the error:

[wldeploy] weblogic.Deployer -debug -verbose -upload -noexit -name idm -source
C:\prj\IDM\image\idm.war -targets MSIDM01 -adminurl t3s://t68idm1.wwk-group.com:
27047 -user weblogic -password ******** -deploy
[wldeploy] weblogic.Deployer invoked with options: -debug -verbose -upload -no
exit -name idm -source C:\prj\IDM\image\idm.war -targets MSIDM01 -adminurl t3s:/
/t68idm1.wwk-group.com:27047 -user weblogic -deploy
[wldeploy] weblogic.deploy.api.tools.deployer.DeployerException: Unable to conn
ect to 't3s://t68idm1.wwk-group.com:27047': Exception occurred while reading the
license file.. Ensure the url represents a running admin server and that the cr
edentials are correct. If using http protocol, tunneling must be enabled on the
admin server.
[wldeploy] at weblogic.deploy.api.tools.deployer.Jsr88Operation.connect(Jsr
88Operation.java:314)
[wldeploy] at weblogic.deploy.api.tools.deployer.Deployer.perform(Deployer.
java:137)
[wldeploy] at weblogic.deploy.api.tools.deployer.Deployer.runBody(Deployer.
java:88)
[wldeploy] at weblogic.utils.compiler.Tool.run(Tool.java:158)
[wldeploy] at weblogic.utils.compiler.Tool.run(Tool.java:115)
[wldeploy] at weblogic.Deployer.run(Deployer.java:70)
[wldeploy] at weblogic.Deployer.mainWithExceptions(Deployer.java:62)
[wldeploy] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[wldeploy] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:39)
[wldeploy] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.java:25)
[wldeploy] at java.lang.reflect.Method.invoke(Method.java:585)
[wldeploy] at weblogic.ant.taskdefs.management.WLDeploy.invokeMain(WLDeploy
.java:419)
[wldeploy] at weblogic.ant.taskdefs.management.WLDeploy.execute(WLDeploy.ja
va:349)
[wldeploy] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja
va:288)
[wldeploy] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[wldeploy] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:39)
[wldeploy] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.java:25)
[wldeploy] at java.lang.reflect.Method.invoke(Method.java:585)
[wldeploy] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchU
tils.java:105)
[wldeploy] at org.apache.tools.ant.Task.perform(Task.java:348)
[wldeploy] at org.apache.tools.ant.Target.execute(Target.java:357)
[wldeploy] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[wldeploy] at org.apache.tools.ant.Project.executeSortedTargets(Project.jav
a:1329)
[wldeploy] at org.apache.tools.ant.Project.executeTarget(Project.java:1298)

[wldeploy] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(De
faultExecutor.java:41)
[wldeploy] at org.apache.tools.ant.Project.executeTargets(Project.java:1181
)
[wldeploy] at org.apache.tools.ant.Main.runBuild(Main.java:758)
[wldeploy] at org.apache.tools.ant.Main.startAnt(Main.java:217)
[wldeploy] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
[wldeploy] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
[wldeploy] Caused by: javax.enterprise.deploy.spi.exceptions.DeploymentManagerC
reationException: [J2EE Deployment SPI:260009]Exception caught for class 'weblog
ic.deploy.api.spi.deploy.internal.ServerConnectionImpl' while attempting to crea
te DeploymentManager: java.lang.RuntimeException: Exception occurred while readi
ng the license file.

Thanks
Oliver

Hi,

I try to deploy an application to WLS 9.2 with the ANT TASK <wldeploy>. It works.

But when I try to use the SSL port from the server, I cannot connect to the server. How can I deploy to WEBLOGIC with ANT Tasks to use the SSL PORT?

Thanks for help

Hi everybody,

I'm new with working with dbunit. When I do a short test I will get follow error:

java.lang.AbstractMethodError: com.microsoft.jdbc.base.BaseDatabaseMetaData.getDatabaseMajorVersion()I
at org.dbunit.util.SQLHelper$3.wrappedCall(SQLHelper.java:295)
at org.dbunit.util.SQLHelper$ExceptionWrapper.executeWrappedCall(SQLHelper.java:666)
at org.dbunit.util.SQLHelper.getDatabaseInfo(SQLHelper.java:293)
at org.dbunit.database.DatabaseConnection.printConnectionInfo(DatabaseConnection.java:156)
at org.dbunit.database.DatabaseConnection.<init>(DatabaseConnection.java:124)
at org.dbunit.database.DatabaseConnection.<init>(DatabaseConnection.java:81)
at org.dbunit.JdbcDatabaseTester.getConnection(JdbcDatabaseTester.java:118)
at org.dbunit.AbstractDatabaseTester.executeOperation(AbstractDatabaseTester.java:186)
at org.dbunit.AbstractDatabaseTester.onSetup(AbstractDatabaseTester.java:103)
at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:156)
at junit.framework.TestCase.runBare(TestCase.java:128)
at junit.framework.TestResult$1.protect(TestResult.java:110)
at junit.framework.TestResult.runProtected(TestResult.java:128)
at junit.framework.TestResult.run(TestResult.java:113)
at junit.framework.TestCase.run(TestCase.java:120)
at junit.framework.TestSuite.runTest(TestSuite.java:228)
at junit.framework.TestSuite.run(TestSuite.java:223)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

The error comes, when I do follow:
@Override
protected IDataSet getDataSet() throws Exception
{
FlatXmlDataSetBuilder builder = new FlatXmlDataSetBuilder();
return builder.build(new File("rsc\\jar\\album_input.xml"));
}



I'm using dbunit 2.4.7 and a MSSQL Database.

Can somebody help me?

Thanks
Oliver

Thanks for help. It was an configuration problem on the exchage server.

Hi Steve,
thanks for the information. But on this case it dosn't help. Maybe I have to explain exacter.

Somebody send an e-mail to an outlook inbox. In this e-mail there are some fomat infos (tables, colour letters, ...) and you can see the informations in outlook. But when I get the mails from the inbox over java I will get a content-type for this mail text/plain. The content for this message is "instance of String". Thats all what I get. Here the code:

Folder folder = store.getFolder("INBOX");
folder.open(Folder.READ);
Message[] message = folder.getMessages();
{
Message m = message[i];
System.out.println("ContentType: " + m.getContentType());
if(m.getContent() instanceof String)
{
// I always get instanceof String back
}

Do you know, whtats going wrong?

Thanks
Oli

Hi,
I want to read mails from an exchange server and then save the files as rft-files. But when I read the messages from the server I lost all format infos (tables, big letters, colours, ...) from the message. It seems that I can read the messages only in the content-type "text/plain".

How can I read messages for the exchange server without loosing the format infos?

Thanks for help
oli

Hi

Since yesterday I have problems with eclipse start.
Normaly I start eclipse with a batch file with follow command:

start /D%PRJ_HOME%\tools %ECL_HOME%\eclipse -vm %JAVA_HOME%\jre\bin\javaw -data %WSP_HOME% -vmargs -Xms 512m -Xmx 1536m -XX:MaxPermSize=128M

Since yesterday I cannot start eclipse with the parameter Xmx 1536m. It works only when I use Xmx 1024m.

Yesterday they installed a few Microsoft Security Patches. I deinstalled all, but it still dosn't work. Have somebody an idea?


I use jdk1.5.0_16.

Thanks for help

I think you need a connectionName and a connectionPassword to connect to the LDAP server

Hi
I try to encrypt the password in a JNDIRealm for a LDAP authentication with tomcat 6.0.10.

Here my context.xml from the tomcat conf-directory:
<Context>

<WatchedResource>WEB-INF/web.xml</WatchedResource>


<Realm className="org.apache.catalina.realm.JNDIRealm"
authentication="simple"
digest="MD5"
connectionName="CN=LDAPUser,OU=LDAP Authentifizierung,OU=Administration,DC=WWK-GROUP,DC=COM"
connectionPassword="digestpassword"
connectionURL="ldap://ldap1.wwk-group.com:389"
debug="99"
referrals="follow"
roleBase="OU=WWK-PROGRAMME,DC=wwk-group,DC=com"
roleName="cn"
roleSearch="(member={0})"
roleSubtree="true"
userBase="OU=WWK-ZD,DC=wwk-group,DC=com"
userRoleName="member"
userSearch="sAMAccountName={0}"
userSubtree="true"/>
</Context>

But it doesn't work. What else must I do?

Thanks for help
Olly

I fixed the error